manual set int year manual set text symbol manual set text isin manual set text company_description manual set link investor_relations Company name: SELECT Company_Name, IndustryId FROM `companies` WHERE `Ticker` = symbol Limit 1 Sektor: SELECT Industry FROM `industries` WHERE IndustryId=IndustryId Limit 1 Kurs: SELECT Date,Close FROM `shareprices_daily` WHERE `Ticker` = symbol Dividende: SELECT Date,Dividend FROM `shareprices_daily` WHERE `Ticker` = symbol 10-Q, 10-K: SELECT `Fiscal Period`, `Source` FROM `balance_full_quarterly` WHERE `Ticker` = symbol AND `Fiscal Year = Year https://www.sec.gov/Archives/edgar/data/1652044/000165204417000014/0001652044-17-000014-index.htm